package com.ruoyi.shangpinxinxi.mapper;

import java.util.List;

import com.ruoyi.shangpinxinxi.domain.Shangpinxinxi;
import com.ruoyi.shangpinxinxi.domain.TestResult;
import org.apache.ibatis.annotations.Mapper;

/**
 * 商品信息Mapper接口
 * 
 * @author ruoyi
 * @date 2023-05-17
 */
@Mapper
public interface ShangpinxinxiMapper 
{
    /**
     * 查询商品信息
     * 
     * @param id 商品信息主键
     * @return 商品信息
     */
    public Shangpinxinxi selectShangpinxinxiById(Long id);

    /**
     * 查询商品信息列表
     * 
     * @param shangpinxinxi 商品信息
     * @return 商品信息集合
     */
    public List<Shangpinxinxi> selectShangpinxinxiList(Shangpinxinxi shangpinxinxi);

    /**
     * 新增商品信息
     * 
     * @param shangpinxinxi 商品信息
     * @return 结果
     */
    public int insertShangpinxinxi(Shangpinxinxi shangpinxinxi);

    /**
     * 修改商品信息
     * 
     * @param shangpinxinxi 商品信息
     * @return 结果
     */
    public int updateShangpinxinxi(Shangpinxinxi shangpinxinxi);

    /**
     * 删除商品信息
     * 
     * @param id 商品信息主键
     * @return 结果
     */
    public int deleteShangpinxinxiById(Long id);

    /**
     * 批量删除商品信息
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteShangpinxinxiByIds(String[] ids);

    public List<String> selectKaixiang();

    public List<Shangpinxinxi> selectShangPinName();

    Shangpinxinxi selectShangpinxinxi2men4Name(String goodNameMen);

    Shangpinxinxi selectShangpinxinxi2kuang4Name(String goodNameKuang);

    Shangpinxinxi selectShangpinxinxi2zhengmen4Name(String goodNameZhengMen);

    List<Shangpinxinxi> selectShangpinxinxiByTestResult(TestResult wujin1t);

    List<Shangpinxinxi> selectShangpinxinxi2LaBaoGai4Name(String leixing);

    List<Shangpinxinxi> selectShangpinxinxi2LaBaoGai4Name();

    List<Shangpinxinxi> selectShangpinxinxi2LeiBie4Name(String leixing);

    List<Shangpinxinxi> selectShangpinxinxi2LeiBie4noshuangkai();

    List<Shangpinxinxi> selectShangpinxinxi2LeiBie4shuangkai();

    List<Shangpinxinxi> selectShangpinxinxiByNameAndSize2(TestResult testResult);

    Shangpinxinxi selectShangpinxinxiByDanhao(String msg);

    String selectWujinTiaoMa(String name);
}
